Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DAYOF

The DAYOF function returns an `INTEGER` in the range of 1 through 7, giving the day of the week on which a specified date falls. A result of `1` refers to Sunday. The result has the same dimensions as the specified DATE expression.

Return Value

INTEGER

Syntax

DAYOF(date-expression)

Arguments

date-expression

  An expression that has the DATE data type, or a text expression that specifies a date. In place of a DATE expression, you can specify a text expression that has values that conform to a valid input style for dates. DAYOF automatically converts the values of the text expression to DATE values, using the current setting of the DATEORDER option to resolve any ambiguity.

Examples

Example 9-38 Finding Today's Weekday

The following statement sends the day of the week on which today's date falls to the current outfile.

    SHOW DAYOF(TODAY)

When today's date is January 15, 1997, which is a Wednesday, this statement produces the following output.

    4

Example 9-39 Finding the Weekday of a Date

The following statement sends the day of the week on which July 4 fell in 1996 to the current outfile.

    SHOW DAYOF('04jul96')

This statement produces the following output.

    5